SELECT OrderID, Freight AS [Current],
       SUM(Freight) OVER (Order BY OrderID) AS RunningTotal
FROM   Orders

SELECT CategoryID, COUNT(*)
FROM  Products
GROUP BY CategoryID

SELECT CategoryID,ProductID, ProductName, 
       COUNT(*) OVER (PARTITION BY CategoryID) AS Kol
FROM  Products
